package DataLayer.DB;

import java.sql.ResultSet;
import java.sql.Statement;

/**
 * GetMax.java
 * 
 * @author kbh
 * @version 26. oktober 2006
 */
public class GetMax
{
	/** Creates a new instance of GetMax */
	public GetMax()
	{
	}

	// getMax is for the primary key in the table
	public static int getMaxId(String query)
	{
		ResultSet results;
		int id = -1;
		try
		{
			Statement stmt = DBConnection.getInstance().getDBcon()
					.createStatement();
			results = stmt.executeQuery(query);
			if (results.next())
			{
				id = results.getInt(1);
			}
		}// slut try
		catch (Exception e)
		{
			System.out.println("Query exception: Error in reading maxid" + e);
		}
		return id;
	}
}
